﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
namespace INTEX.DataBase.Tools
{
    public partial class INTEXDBC
    {
        public void DeleteICC_ABPOS_EXT(DataRow dwData, int option = 1)
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();

            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ICC_ABPOS_EXT WHERE  "
                        + "  ABPFILLER1=:ABPFILLER1 ";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();
                    break;
                case 2:
                    or1.CommandText = "DELETE FROM ICC_ABPOS_EXT WHERE  "
                        + "  ABPAUFKRS=:ABPAUFKRS AND ABPAUFLFD=:ABPAUFLFD AND ABPAUFPOS=:ABPAUFPOS ";
                    or1.Parameters.Add("ABPAUFKRS", OracleType.NVarChar).Value = dwData["ABPAUFKRS"].ToString();
                    or1.Parameters.Add("ABPAUFLFD", OracleType.NVarChar).Value = dwData["ABPAUFLFD"].ToString();
                    or1.Parameters.Add("ABPAUFPOS", OracleType.NVarChar).Value = dwData["ABPAUFPOS"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }
        public void InsertICC_ABPOS_EXT(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setReturn = new DataSet();
            DataSet setResult = new DataSet();
            DataSet setTemp = new DataSet();
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO ICC_ABPOS_EXT(ABPMANDANT, ABPAUFKRS, ABPAUFLFD, ABPAUFPOS, ABPVFAUFKRS, ABPVFAUFLFD, ABPVFAUFPOS, ABPAUFART, ABPAUFST, ABPAUFSTV, ABPAUFSTB, ABPAUTO, ABPPRIO, ABPTLVF, ABPDIVARTKZ, ABPKUNDNR, ABPWERK, ABPABT, ABPWAKZ, ABPART, ABPVAR, ABPFARBE, ABPDESS, ABPCOLORIT, ABPBESCHICH, ABPGROE, ABPAUFM, ABPVERP, ABPANZVP, ABPFWARTGRA, ABPFWARTGRP, ABPZLO, ABPZLB, ABPBLO, ABPSME, ABPSOLLMENGE1, ABPSOLLMENGE2, ABPSOLLMENGE3, ABPSOLLMENGE4, ABPSOLLMENGE5, ABPSOLLMENGE6, ABPSOLLMENGE7, ABPSOLLMENGE8, ABPRESMGE, ABPRESKG, ABPRESSTK, ABPZUGET, ABPZUGKG, ABPZUGSTK, ABPDILFM, ABPDIKG, ABPDISTK, ABPZTLGKOMP, ABPSMGKZZU, ABPVLLFM, ABPVLKG, ABPVLSTK, ABPEALFM, ABPEAKG, ABPEASTK, ABPEBLFM, ABPEBKG, ABPEBSTK, ABPABLFM, ABPABKG, ABPABSTK, ABPVSLFM, ABPVSKG, ABPVSSTK, ABPRTLFM, ABPRTKG, ABPRTSTK, ABPROHWDAT, ABPKDDAT, ABPWVDAT, ABPLIEFDAT, ABPLRUECK, ABPLRDATE, ABPDLR, ABPVTRUECK, ABPVTDATE, ABPUNKLAR, ABPVERSDAT, ABPFREIDAT, ABPSTARTDAT, ABPENDDAT, ABPSTARTDATA, ABPENDDATA, ABPLTERMAK, ABPBESTDAT, ABPANRKR, ABPALFDNR, ABPAFOLGEV, ABPAFOLGEB, ABPANRKR2, ABPALFDNR2, ABPAFOLGEV2, ABPAFOLGEB2, ABPANRKR3, ABPALFDNR3, ABPAFOLGEV3, ABPAFOLGEB3, ABPANRKR4, ABPALFDNR4, ABPAFOLGEV4, ABPAFOLGEB4, ABPVERSAEND, ABPVERSZL, ABPTLFREIG, ABPTLFMG, ABPFREIGKZ, ABPLMAFOLGE, ABPENDAUFM, ABPZAUFM, ABPLIEFNR, ABPGESSTA, ABPKDSTA, ABPWSSTA, ABPAPSTA, ABPRZSTA, ABPWPSTA, ABPWBSTA, ABPABSTA, ABPERLKZ, ABPERLDAT, ABPBEWKZ, ABPDRKZ1, ABPDRKZ2, ABPDRKZ3, ABPDRKZ4, ABPDRKZ5, ABPDRKZ6, ABPDRKZ7, ABPDRKZ8, ABPDRKZ9, ABPDRKZ10, ABPDR1USER, ABPDR1DAT, ABPDR8USER, ABPDR8DAT, ABPRETOURZL, ABPRPCOUNTAK, ABPURAUFKRS, ABPURAUFLFD, ABPURAUFPOS, ABPASAUFKRS, ABPASAUFLFD, ABPASAUFPOS, ABPREAFOLGE, ABPRWKRS, ABPRWLFD, ABPSTKNRKR, ABPSERIE, ABPAGBKZ, ABPWAART, ABPANZSTK, ABPZUGETGES, ABPSTKKZ, ABPSTKLG, ABPANZSTKR, ABPABZKZ, ABPBDEKZ, ABPSUBSYS, ABPDATBDE, ABPUHRBDE, ABPDISPOKZ, ABPSCHLICHTE, ABPZZUSATZ, ABPZZUSKZ, ABPSZUSTAND, ABPIZUSTAND, ABPSZUSATZKZ1, ABPSZUSATZKZ2, ABPSZUSATZKZ3, ABPSZUSATZKZ4, ABPWERKE, ABPLBMUSTR, ABPFBMUSTR, ABPREAUFKRS, ABPREAUFLFD, ABPREAUFPOS, ABPLTVORL, ABPFDZ, ABPARTEX, ABPLETEILNR, ABPANSNR, ABPUPOS, ABPTP, ABPLBDENR, ABPTMCOUNT, ABPTMCOUNTAK, ABPKDPARTIE, ABPBAHNKZ, ABPGAENGE, ABPZWTWAHL, ABPDIVWLFM, ABPDIVWKG, ABPDISPOST, ABPKETTAUFT, ABPKETTGARN, ABPSPGRD, ABPSPBENID, ABPSPDAT, ABPLMDAT, ABPLMZT, ABPWPLKZ, ABPKKUNDNR, ABPKLAND, ABPKVB, ABPKVG, ABPKPROGRP, ABPKARTGRP, ABPKVKZ, ABPLAEVON, ABPLAEBIS, ABPSTDLAE, ABPMGV, ABPMGB, ABPPAS, ABPPAI, ABPAZUTEIL, ABPZUTART, ABPFA, ABPGA, ABPQA, ABPMAFZST, ABPQPKTH, ABPQPKTLH, ABPSTKNEUTR, ABPREGEL, ABPSTAFFNR, ABPWERKEKZ, ABPWKSTKRS, ABPWKST, ABPWKART, ABPWMNRKRS, ABPWMLFDNR, ABPWMPOS, ABPWMODNR, ABPWINTV, ABPWKENN, ABPWSTOERGRD, ABPWAKSTKRS, ABPWAKST, ABPWPERSNR, ABPWDATV, ABPWZEITV, ABPWDATB, ABPWZEITB, ABPWSTA, ABPFKALK, ABPLIEFDATN, ABPLAEAENDE, ABPLAEAENDA, ABPDMWAKZ, ABPDMART, ABPDMVAR, ABPDMDESS, ABPDMCOLORIT, ABPDMFARBE, ABPDMBESCHICH, ABPDKART, ABPDKVAR, ABPDKFARBE, ABPDKBRUT, ABPGENEHMKZ, ABPSTUEART, ABPCOMPKZ, ABPPOSTYP, ABPORDER, ABPNPGRUND, ABPREWEIL, ABPFSCHL, ABPKSTKRS, ABPKST, ABPMURW, ABPMUVB, ABPMUFW, ABPMUPF, ABPERSTFB, ABPERSTDR, ABPERSTBE, ABPMUCTOD, ABPKDFREI, ABPREZFB, ABPREZDR, ABPPRUEF, ABPNIXWE, ABPCOLSTA, ABPFBSTA, ABPBAHNNR, ABPBAHNBRT, ABPFLBEDECK, ABPDATABDE, ABPUHRABDE, ABPLOEKZ, ABPTERMDAT, ABPPRFI, ABPPRVAR, ABPPRBE, ABPPRZU, ABPPRDESS, ABPZUSATZ1, ABPZUSATZ2, ABPZUSATZ3, ABPZUSATZ4, ABPZUSATZ5, ABPFLAG1, ABPFLAG2, ABPFLAG3, ABPFLAG4, ABPFLAG5, ABPORGMG, ABPDIFFMG, ABPRARTKZ, ABPSTARTDATN, ABPAESTAT, ABPLBAUFKRS, ABPLBAUFLFD, ABPLBAUFPOS, ABPVEAUFTRAG, ABPREGBLOG, ABPREGBDATE, ABPPROJNR, ABPSHADE, ABPSHADEUNCL, ABPLICHTART, ABPLINE, ABPFILLER1, ABPAENDZL, ABPAENDBEN, ABPAENDDAT, ABPNEUBEN, ABPNEUDAT)"
            + "VALUES (:ABPMANDANT, :ABPAUFKRS, :ABPAUFLFD, :ABPAUFPOS, '  ', '000000', '000',:ABPAUFART, ' ', '0', '0', ' ', '00', '   ', ' ', '00000000', '   ', '   '"
            + ", ' ', '                    ', '   ', '          ', '          ', '          ', '          ', '       ', '  ', '   ', 0, '     ', '  ', '  ', '  ', '  ', '1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0"
            + ", 0, 0, 0, '  ', 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, '  ', '      ', '000', '000', '  ', '000000', 0, 0, '  ', '000000', 0, 0, '  ', '000000', 0, 0, ' ', '006', '000', 0, ' ', '000', '  ', '  ', '        ', 'TE', '10'"
            + ", '20', '30', '40', '50', '60', '70', ' ', 0, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '        ', '00000000', '        ', '00000000', 0, 0, '  ', '000000', '000', '  ', '000000', '000', '000', '  ', '000000'"
            + ", '  ', '  ', ' ', '   ', 0, 0, ' ', 0, 0, ' ', 'N', '  ', 0, 0, ' ', '     ', '          ', ' ', '    ', '    ', ' ', ' ', ' ', ' ', ' ', '   ', '   ', '  ', '000000', '000', '               ', 0, '                                                            '"
            + ", 0, 0, 0, 0, 0, 1, 0, '          ', ' ', 0, 0, 0, 0, ' ', ' ', ' ', '  ', '        ', 0, 0, 0, ' ', '        ', '   ', '   ', '   ', '   ', '   ', ' ', 0, 0, 0, 0, 0, 0, 0, ' ', ' ', 0, 0, 0, 0, 0, 0, ' ', '00000000', '00', ' ', '  ', '0000'"
            + ", '000000', '  ', '0000', '00', '000', '00', '  ', '               ', '  ', '0000', '        ', 0, 0, 0, 0, '  ', ' ', 0, 0, 0, ' ', '                    ', '  ', '          ', '          ', '          ', '          ', '                    '"
            + ", '  ', '  ', 0, ' ', '   ', ' ', '   ', '    ', '   ', '  ', '   ', '  ', '0000', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '0', 0, 0, '00000000', '000000', ' ', '        ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 0"
            + ", 0, 0, 0, 0, 0, 0, ' ', '        ', ' ', '  ', '000000', '000', '               ', 0, 0, '                        ', '   ', ' ', '     ', '   ', :ABPFILLER1"
            + ", 1, '        ', 0,:ABPNEUBEN, :ABPNEUDAT)";
            or1.Parameters.Add("ABPMANDANT", OracleType.NVarChar).Value = dwData["ABPMANDANT"];
            or1.Parameters.Add("ABPAUFKRS", OracleType.NVarChar).Value = dwData["ABPAUFKRS"];
            or1.Parameters.Add("ABPAUFLFD", OracleType.NVarChar).Value = dwData["ABPAUFLFD"];
            or1.Parameters.Add("ABPAUFPOS", OracleType.NVarChar).Value = dwData["ABPAUFPOS"];
            or1.Parameters.Add("ABPAUFART", OracleType.NVarChar).Value = dwData["ABPAUFART"];
            or1.Parameters.Add("ABPNEUBEN", OracleType.NVarChar).Value = dwData["ABPNEUBEN"];
            or1.Parameters.Add("ABPNEUDAT", OracleType.NVarChar).Value = dwData["ABPNEUDAT"];
            or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"];
            Connect2Proxy(or1);
        }
        public void MapICC_ABPOS_EXT(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public DataSet QueryICC_ABPOS_EXT(DataRow dwData, int option = 1)
        {
            DataSet setReturn = new DataSet();
            DataSet Result = new DataSet();
            DataTable tbLocal = null;
            OracleCommand or1 = null;
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "SELECT * FROM ICC_ABPOS_EXT WHERE  ABPAUFKRS=:ABPAUFKRS AND ABPAUFLFD=:ABPAUFLFD AND ABPAUFPOS=:ABPAUFPOS";
                    or1.Parameters.Add("ABPAUFKRS", OracleType.NVarChar).Value = dwData["ABPAUFKRS"];
                    or1.Parameters.Add("ABPAUFLFD", OracleType.NVarChar).Value = dwData["ABPAUFLFD"];
                    or1.Parameters.Add("ABPAUFPOS", OracleType.NVarChar).Value = dwData["ABPAUFPOS"]; 
                    break;
                case 2:
                    or1.CommandText = "SELECT * FROM ICC_ABPOS_EXT WHERE  ABPAUFKRS=:ABPAUFKRS AND ABPAUFLFD=:ABPAUFLFD";
                    or1.Parameters.Add("ABPAUFKRS", OracleType.NVarChar).Value = dwData["ABPAUFKRS"];
                    or1.Parameters.Add("ABPAUFLFD", OracleType.NVarChar).Value = dwData["ABPAUFLFD"]; 
                    break;
                case 99:
                    or1.CommandText = "SELECT * FROM ICC_ABPOS_EXT WHERE  ABPGESSTA<>'FN'";
                    break;
                default:
                    break;
            }

            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
            {
                tbLocal = Result.Tables[0];
                tbLocal.TableName = "ICC_ABPOS_EXT";
            }
            setReturn.Merge(Result);
            return setReturn;
        }
        public void SaveICC_ABPOS_EXT(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryICC_ABPOS_EXT(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapICC_ABPOS_EXT(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertICC_ABPOS_EXT(dwLocal, ITXDBVERSION);
            }
            UpdateICC_ABPOS_EXT(dwLocal);
        }

        public void UpdateICC_ABPOS_EXT(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "50.24":
                    #region=====Part1=======
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                        + "ABPVFAUFKRS=:ABPVFAUFKRS,"
                        + "ABPVFAUFLFD=:ABPVFAUFLFD,"
                        + "ABPVFAUFPOS=:ABPVFAUFPOS,"
                        + "ABPAUFART=:ABPAUFART,"
                        + "ABPAUFST=:ABPAUFST,"
                        + "ABPAUFSTV=:ABPAUFSTV,"
                        + "ABPAUFSTB=:ABPAUFSTB,"
                   + "ABPAUTO=:ABPAUTO,"
                   + "ABPPRIO=:ABPPRIO,"
                   + "ABPTLVF=:ABPTLVF,"
                   + "ABPDIVARTKZ=:ABPDIVARTKZ,"
                   + "ABPKUNDNR=:ABPKUNDNR,"
                   + "ABPWERK=:ABPWERK,"
                   + "ABPABT=:ABPABT,"
                   + "ABPWAKZ=:ABPWAKZ,"
                   + "ABPART=:ABPART,"
                   + "ABPVAR=:ABPVAR,"
                   + "ABPFARBE=:ABPFARBE,"
                   + "ABPDESS=:ABPDESS,"
                   + "ABPCOLORIT=:ABPCOLORIT,"
                   + "ABPBESCHICH=:ABPBESCHICH,"
                   + "ABPGROE=:ABPGROE,"
                   + "ABPAUFM=:ABPAUFM,"
                   + "ABPVERP=:ABPVERP,"
                   + "ABPANZVP=:ABPANZVP,"
                   + "ABPFWARTGRA=:ABPFWARTGRA,"
                   + "ABPFWARTGRP=:ABPFWARTGRP,"
                   + "ABPZLO=:ABPZLO,"
                   + "ABPZLB=:ABPZLB,"
                   + "ABPBLO=:ABPBLO,"
                   + "ABPSME=:ABPSME,"
                   + "ABPSOLLMENGE1=:ABPSOLLMENGE1,"
                   + "ABPSOLLMENGE2=:ABPSOLLMENGE2,"
                   + "ABPSOLLMENGE3=:ABPSOLLMENGE3,"
                   + "ABPSOLLMENGE4=:ABPSOLLMENGE4,"
                   + "ABPSOLLMENGE5=:ABPSOLLMENGE5,"
                   + "ABPSOLLMENGE6=:ABPSOLLMENGE6,"
                   + "ABPSOLLMENGE7=:ABPSOLLMENGE7,"
                   + "ABPSOLLMENGE8=:ABPSOLLMENGE8,"
                   + "ABPRESMGE=:ABPRESMGE,"
                   + "ABPRESKG=:ABPRESKG,"
                   + "ABPRESSTK=:ABPRESSTK,"
                   + "ABPZUGET=:ABPZUGET,"
                   + "ABPZUGKG=:ABPZUGKG,"
                   + "ABPZUGSTK=:ABPZUGSTK,"
                   + "ABPDILFM=:ABPDILFM,"
                   + "ABPDIKG=:ABPDIKG,"
                   + "ABPDISTK=:ABPDISTK,"
                   + "ABPZTLGKOMP=:ABPZTLGKOMP,"
                   + "ABPSMGKZZU=:ABPSMGKZZU,"
                   + "ABPVLLFM=:ABPVLLFM,"
                   + "ABPVLKG=:ABPVLKG,"
                   + "ABPVLSTK=:ABPVLSTK,"
                   + "ABPEALFM=:ABPEALFM,"
                   + "ABPEAKG=:ABPEAKG,"
                   + "ABPEASTK=:ABPEASTK,"
                   + "ABPEBLFM=:ABPEBLFM,"
                   + "ABPEBKG=:ABPEBKG,"
                   + "ABPEBSTK=:ABPEBSTK,"
                   + "ABPABLFM=:ABPABLFM,"
                   + "ABPABKG=:ABPABKG,"
                   + "ABPABSTK=:ABPABSTK,"
                   + "ABPVSLFM=:ABPVSLFM,"
                   + "ABPVSKG=:ABPVSKG,"
                   + "ABPVSSTK=:ABPVSSTK,"
                   + "ABPRTLFM=:ABPRTLFM,"
                   + "ABPRTKG=:ABPRTKG,"
                   + "ABPRTSTK=:ABPRTSTK,"
                   + "ABPROHWDAT=:ABPROHWDAT,"
                   + "ABPKDDAT=:ABPKDDAT,"
                   + "ABPWVDAT=:ABPWVDAT,"
                   + "ABPLIEFDAT=:ABPLIEFDAT,"
                   + "ABPLRUECK=:ABPLRUECK,"
                   + "ABPLRDATE=:ABPLRDATE,"
                   + "ABPDLR=:ABPDLR,"
                   + "ABPVTRUECK=:ABPVTRUECK,"
                   + "ABPVTDATE=:ABPVTDATE,"
                   + "ABPUNKLAR=:ABPUNKLAR,"
                   + "ABPVERSDAT=:ABPVERSDAT,"
                   + "ABPFREIDAT=:ABPFREIDAT,"
                   + "ABPSTARTDAT=:ABPSTARTDAT,"
                   + "ABPENDDAT=:ABPENDDAT,"
                   + "ABPSTARTDATA=:ABPSTARTDATA,"
                   + "ABPENDDATA=:ABPENDDATA,"
                   + "ABPLTERMAK=:ABPLTERMAK,"
                   + "ABPBESTDAT=:ABPBESTDAT,"
                   + "ABPANRKR=:ABPANRKR,"
                   + "ABPALFDNR=:ABPALFDNR,"
                   + "ABPAFOLGEV=:ABPAFOLGEV,"
                   + "ABPAFOLGEB=:ABPAFOLGEB,"
                   + "ABPANRKR2=:ABPANRKR2,"
                   + "ABPALFDNR2=:ABPALFDNR2,"
                   + "ABPAFOLGEV2=:ABPAFOLGEV2,"
                   + "ABPAFOLGEB2=:ABPAFOLGEB2,"
                   + "ABPANRKR3=:ABPANRKR3,"
                   + "ABPALFDNR3=:ABPALFDNR3,"
                   + "ABPAFOLGEV3=:ABPAFOLGEV3,"
                   + "ABPAFOLGEB3=:ABPAFOLGEB3,"
                   + "ABPANRKR4=:ABPANRKR4,"
                   + "ABPALFDNR4=:ABPALFDNR4,"
                   + "ABPAFOLGEV4=:ABPAFOLGEV4,"
                   + "ABPAFOLGEB4=:ABPAFOLGEB4,"
                   + "ABPVERSAEND=:ABPVERSAEND,"
                   + "ABPVERSZL=:ABPVERSZL,"
                   + "ABPTLFREIG=:ABPTLFREIG,"
                   + "ABPTLFMG=:ABPTLFMG,"
                   + "ABPFREIGKZ=:ABPFREIGKZ,"
                   + "ABPLMAFOLGE=:ABPLMAFOLGE,"
                   + "ABPENDAUFM=:ABPENDAUFM,"
                   + "ABPZAUFM=:ABPZAUFM,"
                   + "ABPLIEFNR=:ABPLIEFNR,"
                   + "ABPGESSTA=:ABPGESSTA,"
                   + "ABPKDSTA=:ABPKDSTA,"
                   + "ABPWSSTA=:ABPWSSTA,"
                   + "ABPAPSTA=:ABPAPSTA,"
                   + "ABPRZSTA=:ABPRZSTA,"
                   + "ABPWPSTA=:ABPWPSTA,"
                   + "ABPWBSTA=:ABPWBSTA,"
                   + "ABPABSTA=:ABPABSTA,"
                   + "ABPERLKZ=:ABPERLKZ,"
                   + "ABPERLDAT=:ABPERLDAT,"
                   + "ABPBEWKZ=:ABPBEWKZ,"
                   + "ABPDRKZ1=:ABPDRKZ1,"
                   + "ABPDRKZ2=:ABPDRKZ2,"
                   + "ABPDRKZ3=:ABPDRKZ3,"
                   + "ABPDRKZ4=:ABPDRKZ4,"
                   + "ABPDRKZ5=:ABPDRKZ5,"
                   + "ABPDRKZ6=:ABPDRKZ6,"
                   + "ABPDRKZ7=:ABPDRKZ7,"
                   + "ABPDRKZ8=:ABPDRKZ8,"
                   + "ABPDRKZ9=:ABPDRKZ9,"
                   + "ABPDRKZ10=:ABPDRKZ10,"
                   + "ABPDR1USER=:ABPDR1USER,"
                   + "ABPDR1DAT=:ABPDR1DAT,"
                   + "ABPDR8USER=:ABPDR8USER,"
                   + "ABPDR8DAT=:ABPDR8DAT,"
                   + "ABPRETOURZL=:ABPRETOURZL,"
                   + "ABPRPCOUNTAK=:ABPRPCOUNTAK,"
                   + "ABPURAUFKRS=:ABPURAUFKRS,"
                   + "ABPURAUFLFD=:ABPURAUFLFD,"
                   + "ABPURAUFPOS=:ABPURAUFPOS,"
                   + "ABPASAUFKRS=:ABPASAUFKRS,"
                   + "ABPASAUFLFD=:ABPASAUFLFD,"
                   + "ABPASAUFPOS=:ABPASAUFPOS,"
                   + "ABPREAFOLGE=:ABPREAFOLGE,"
                   + "ABPRWKRS=:ABPRWKRS,"
                   + "ABPRWLFD=:ABPRWLFD,"
                   + "ABPSTKNRKR=:ABPSTKNRKR,"
                   + "ABPSERIE=:ABPSERIE,"
                   + "ABPAGBKZ=:ABPAGBKZ,"
                   + "ABPWAART=:ABPWAART,"
                   + "ABPANZSTK=:ABPANZSTK,"
                   + "ABPZUGETGES=:ABPZUGETGES,"
                   + "ABPSTKKZ=:ABPSTKKZ,"
                   + "ABPSTKLG=:ABPSTKLG,"
                   + "ABPANZSTKR=:ABPANZSTKR,"
                   + "ABPABZKZ=:ABPABZKZ,"
                   + "ABPBDEKZ=:ABPBDEKZ,"
                   + "ABPSUBSYS=:ABPSUBSYS,"
                   + "ABPDATBDE=:ABPDATBDE,"
                   + "ABPUHRBDE=:ABPUHRBDE,"
                   + "ABPDISPOKZ=:ABPDISPOKZ,"
                   + "ABPSCHLICHTE=:ABPSCHLICHTE,"
                   + "ABPZZUSATZ=:ABPZZUSATZ,"
                   + "ABPZZUSKZ=:ABPZZUSKZ,"
                   + "ABPSZUSTAND=:ABPSZUSTAND,"
                   + "ABPIZUSTAND=:ABPIZUSTAND,"
                   + "ABPSZUSATZKZ1=:ABPSZUSATZKZ1,"
                   + "ABPSZUSATZKZ2=:ABPSZUSATZKZ2,"
                   + "ABPSZUSATZKZ3=:ABPSZUSATZKZ3,"
                   + "ABPSZUSATZKZ4=:ABPSZUSATZKZ4,"
                   + "ABPWERKE=:ABPWERKE,"
                   + "ABPLBMUSTR=:ABPLBMUSTR,"
                   + "ABPFBMUSTR=:ABPFBMUSTR,"
                   + "ABPREAUFKRS=:ABPREAUFKRS,"
                   + "ABPREAUFLFD=:ABPREAUFLFD,"
                   + "ABPREAUFPOS=:ABPREAUFPOS,"
                   + "ABPLTVORL=:ABPLTVORL,"
                   + "ABPFDZ=:ABPFDZ,"
                   + "ABPARTEX=:ABPARTEX,"
                   + "ABPLETEILNR=:ABPLETEILNR,"
                   + "ABPANSNR=:ABPANSNR,"
                   + "ABPUPOS=:ABPUPOS,"
                   + "ABPTP=:ABPTP,"
                   + "ABPLBDENR=:ABPLBDENR,"
                   + "ABPTMCOUNT=:ABPTMCOUNT,"
                   + "ABPTMCOUNTAK=:ABPTMCOUNTAK,"
                   + "ABPKDPARTIE=:ABPKDPARTIE,"
                   + "ABPBAHNKZ=:ABPBAHNKZ,"
                   + "ABPGAENGE=:ABPGAENGE,"
                   + "ABPZWTWAHL=:ABPZWTWAHL,"
                   + "ABPDIVWLFM=:ABPDIVWLFM,"
                   + "ABPDIVWKG=:ABPDIVWKG "
                   + " WHERE  "
                   + "  ABPFILLER1=:ABPFILLER1 ";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPVFAUFKRS", OracleType.NVarChar).Value = dwData["ABPVFAUFKRS"].ToString();
                    or1.Parameters.Add("ABPVFAUFLFD", OracleType.NVarChar).Value = dwData["ABPVFAUFLFD"].ToString();
                    or1.Parameters.Add("ABPVFAUFPOS", OracleType.NVarChar).Value = dwData["ABPVFAUFPOS"].ToString();
                    or1.Parameters.Add("ABPAUFART", OracleType.NVarChar).Value = dwData["ABPAUFART"].ToString();
                    or1.Parameters.Add("ABPAUFST", OracleType.NVarChar).Value = dwData["ABPAUFST"].ToString();
                    or1.Parameters.Add("ABPAUFSTV", OracleType.NVarChar).Value = dwData["ABPAUFSTV"].ToString();
                    or1.Parameters.Add("ABPAUFSTB", OracleType.NVarChar).Value = dwData["ABPAUFSTB"].ToString();
                    or1.Parameters.Add("ABPAUTO", OracleType.NVarChar).Value = dwData["ABPAUTO"].ToString();
                    or1.Parameters.Add("ABPPRIO", OracleType.NVarChar).Value = dwData["ABPPRIO"].ToString();
                    or1.Parameters.Add("ABPTLVF", OracleType.NVarChar).Value = dwData["ABPTLVF"].ToString();
                    or1.Parameters.Add("ABPDIVARTKZ", OracleType.NVarChar).Value = dwData["ABPDIVARTKZ"].ToString();
                    or1.Parameters.Add("ABPKUNDNR", OracleType.NVarChar).Value = dwData["ABPKUNDNR"].ToString();
                    or1.Parameters.Add("ABPWERK", OracleType.NVarChar).Value = dwData["ABPWERK"].ToString();
                    or1.Parameters.Add("ABPABT", OracleType.NVarChar).Value = dwData["ABPABT"].ToString();
                    or1.Parameters.Add("ABPWAKZ", OracleType.NVarChar).Value = dwData["ABPWAKZ"].ToString();
                    or1.Parameters.Add("ABPART", OracleType.NVarChar).Value = dwData["ABPART"].ToString();
                    or1.Parameters.Add("ABPVAR", OracleType.NVarChar).Value = dwData["ABPVAR"].ToString();
                    or1.Parameters.Add("ABPFARBE", OracleType.NVarChar).Value = dwData["ABPFARBE"].ToString();
                    or1.Parameters.Add("ABPDESS", OracleType.NVarChar).Value = dwData["ABPDESS"].ToString();
                    or1.Parameters.Add("ABPCOLORIT", OracleType.NVarChar).Value = dwData["ABPCOLORIT"].ToString();
                    or1.Parameters.Add("ABPBESCHICH", OracleType.NVarChar).Value = dwData["ABPBESCHICH"].ToString();
                    or1.Parameters.Add("ABPGROE", OracleType.NVarChar).Value = dwData["ABPGROE"].ToString();
                    or1.Parameters.Add("ABPAUFM", OracleType.NVarChar).Value = dwData["ABPAUFM"].ToString();
                    or1.Parameters.Add("ABPVERP", OracleType.NVarChar).Value = dwData["ABPVERP"].ToString();
                    or1.Parameters.Add("ABPANZVP", OracleType.NVarChar).Value = dwData["ABPANZVP"].ToString();
                    or1.Parameters.Add("ABPFWARTGRA", OracleType.NVarChar).Value = dwData["ABPFWARTGRA"].ToString();
                    or1.Parameters.Add("ABPFWARTGRP", OracleType.NVarChar).Value = dwData["ABPFWARTGRP"].ToString();
                    or1.Parameters.Add("ABPZLO", OracleType.NVarChar).Value = dwData["ABPZLO"].ToString();
                    or1.Parameters.Add("ABPZLB", OracleType.NVarChar).Value = dwData["ABPZLB"].ToString();
                    or1.Parameters.Add("ABPBLO", OracleType.NVarChar).Value = dwData["ABPBLO"].ToString();
                    or1.Parameters.Add("ABPSME", OracleType.NVarChar).Value = dwData["ABPSME"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE1", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE1"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE2", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE2"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE3", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE3"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE4", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE4"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE5", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE5"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE6", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE6"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE7", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE7"].ToString();
                    or1.Parameters.Add("ABPSOLLMENGE8", OracleType.NVarChar).Value = dwData["ABPSOLLMENGE8"].ToString();
                    or1.Parameters.Add("ABPRESMGE", OracleType.NVarChar).Value = dwData["ABPRESMGE"].ToString();
                    or1.Parameters.Add("ABPRESKG", OracleType.NVarChar).Value = dwData["ABPRESKG"].ToString();
                    or1.Parameters.Add("ABPRESSTK", OracleType.NVarChar).Value = dwData["ABPRESSTK"].ToString();
                    or1.Parameters.Add("ABPZUGET", OracleType.NVarChar).Value = dwData["ABPZUGET"].ToString();
                    or1.Parameters.Add("ABPZUGKG", OracleType.NVarChar).Value = dwData["ABPZUGKG"].ToString();
                    or1.Parameters.Add("ABPZUGSTK", OracleType.NVarChar).Value = dwData["ABPZUGSTK"].ToString();
                    or1.Parameters.Add("ABPDILFM", OracleType.NVarChar).Value = dwData["ABPDILFM"].ToString();
                    or1.Parameters.Add("ABPDIKG", OracleType.NVarChar).Value = dwData["ABPDIKG"].ToString();
                    or1.Parameters.Add("ABPDISTK", OracleType.NVarChar).Value = dwData["ABPDISTK"].ToString();
                    or1.Parameters.Add("ABPZTLGKOMP", OracleType.NVarChar).Value = dwData["ABPZTLGKOMP"].ToString();
                    or1.Parameters.Add("ABPSMGKZZU", OracleType.NVarChar).Value = dwData["ABPSMGKZZU"].ToString();
                    or1.Parameters.Add("ABPVLLFM", OracleType.NVarChar).Value = dwData["ABPVLLFM"].ToString();
                    or1.Parameters.Add("ABPVLKG", OracleType.NVarChar).Value = dwData["ABPVLKG"].ToString();
                    or1.Parameters.Add("ABPVLSTK", OracleType.NVarChar).Value = dwData["ABPVLSTK"].ToString();
                    or1.Parameters.Add("ABPEALFM", OracleType.NVarChar).Value = dwData["ABPEALFM"].ToString();
                    or1.Parameters.Add("ABPEAKG", OracleType.NVarChar).Value = dwData["ABPEAKG"].ToString();
                    or1.Parameters.Add("ABPEASTK", OracleType.NVarChar).Value = dwData["ABPEASTK"].ToString();
                    or1.Parameters.Add("ABPEBLFM", OracleType.NVarChar).Value = dwData["ABPEBLFM"].ToString();
                    or1.Parameters.Add("ABPEBKG", OracleType.NVarChar).Value = dwData["ABPEBKG"].ToString();
                    or1.Parameters.Add("ABPEBSTK", OracleType.NVarChar).Value = dwData["ABPEBSTK"].ToString();
                    or1.Parameters.Add("ABPABLFM", OracleType.NVarChar).Value = dwData["ABPABLFM"].ToString();
                    or1.Parameters.Add("ABPABKG", OracleType.NVarChar).Value = dwData["ABPABKG"].ToString();
                    or1.Parameters.Add("ABPABSTK", OracleType.NVarChar).Value = dwData["ABPABSTK"].ToString();
                    or1.Parameters.Add("ABPVSLFM", OracleType.NVarChar).Value = dwData["ABPVSLFM"].ToString();
                    or1.Parameters.Add("ABPVSKG", OracleType.NVarChar).Value = dwData["ABPVSKG"].ToString();
                    or1.Parameters.Add("ABPVSSTK", OracleType.NVarChar).Value = dwData["ABPVSSTK"].ToString();
                    or1.Parameters.Add("ABPRTLFM", OracleType.NVarChar).Value = dwData["ABPRTLFM"].ToString();
                    or1.Parameters.Add("ABPRTKG", OracleType.NVarChar).Value = dwData["ABPRTKG"].ToString();
                    or1.Parameters.Add("ABPRTSTK", OracleType.NVarChar).Value = dwData["ABPRTSTK"].ToString();
                    or1.Parameters.Add("ABPROHWDAT", OracleType.NVarChar).Value = dwData["ABPROHWDAT"].ToString();
                    or1.Parameters.Add("ABPKDDAT", OracleType.NVarChar).Value = dwData["ABPKDDAT"].ToString();
                    or1.Parameters.Add("ABPWVDAT", OracleType.NVarChar).Value = dwData["ABPWVDAT"].ToString();
                    or1.Parameters.Add("ABPLIEFDAT", OracleType.NVarChar).Value = dwData["ABPLIEFDAT"].ToString();
                    or1.Parameters.Add("ABPLRUECK", OracleType.NVarChar).Value = dwData["ABPLRUECK"].ToString();
                    or1.Parameters.Add("ABPLRDATE", OracleType.NVarChar).Value = dwData["ABPLRDATE"].ToString();
                    or1.Parameters.Add("ABPDLR", OracleType.NVarChar).Value = dwData["ABPDLR"].ToString();
                    or1.Parameters.Add("ABPVTRUECK", OracleType.NVarChar).Value = dwData["ABPVTRUECK"].ToString();
                    or1.Parameters.Add("ABPVTDATE", OracleType.NVarChar).Value = dwData["ABPVTDATE"].ToString();
                    or1.Parameters.Add("ABPUNKLAR", OracleType.NVarChar).Value = dwData["ABPUNKLAR"].ToString();
                    or1.Parameters.Add("ABPVERSDAT", OracleType.NVarChar).Value = dwData["ABPVERSDAT"].ToString();
                    or1.Parameters.Add("ABPFREIDAT", OracleType.NVarChar).Value = dwData["ABPFREIDAT"].ToString();
                    or1.Parameters.Add("ABPSTARTDAT", OracleType.NVarChar).Value = dwData["ABPSTARTDAT"].ToString();
                    or1.Parameters.Add("ABPENDDAT", OracleType.NVarChar).Value = dwData["ABPENDDAT"].ToString();
                    or1.Parameters.Add("ABPSTARTDATA", OracleType.NVarChar).Value = dwData["ABPSTARTDATA"].ToString();
                    or1.Parameters.Add("ABPENDDATA", OracleType.NVarChar).Value = dwData["ABPENDDATA"].ToString();
                    or1.Parameters.Add("ABPLTERMAK", OracleType.NVarChar).Value = dwData["ABPLTERMAK"].ToString();
                    or1.Parameters.Add("ABPBESTDAT", OracleType.NVarChar).Value = dwData["ABPBESTDAT"].ToString();
                    or1.Parameters.Add("ABPANRKR", OracleType.NVarChar).Value = dwData["ABPANRKR"].ToString();
                    or1.Parameters.Add("ABPALFDNR", OracleType.NVarChar).Value = dwData["ABPALFDNR"].ToString();
                    or1.Parameters.Add("ABPAFOLGEV", OracleType.NVarChar).Value = dwData["ABPAFOLGEV"].ToString();
                    or1.Parameters.Add("ABPAFOLGEB", OracleType.NVarChar).Value = dwData["ABPAFOLGEB"].ToString();
                    or1.Parameters.Add("ABPANRKR2", OracleType.NVarChar).Value = dwData["ABPANRKR2"].ToString();
                    or1.Parameters.Add("ABPALFDNR2", OracleType.NVarChar).Value = dwData["ABPALFDNR2"].ToString();
                    or1.Parameters.Add("ABPAFOLGEV2", OracleType.NVarChar).Value = dwData["ABPAFOLGEV2"].ToString();
                    or1.Parameters.Add("ABPAFOLGEB2", OracleType.NVarChar).Value = dwData["ABPAFOLGEB2"].ToString();
                    or1.Parameters.Add("ABPANRKR3", OracleType.NVarChar).Value = dwData["ABPANRKR3"].ToString();
                    or1.Parameters.Add("ABPALFDNR3", OracleType.NVarChar).Value = dwData["ABPALFDNR3"].ToString();
                    or1.Parameters.Add("ABPAFOLGEV3", OracleType.NVarChar).Value = dwData["ABPAFOLGEV3"].ToString();
                    or1.Parameters.Add("ABPAFOLGEB3", OracleType.NVarChar).Value = dwData["ABPAFOLGEB3"].ToString();
                    or1.Parameters.Add("ABPANRKR4", OracleType.NVarChar).Value = dwData["ABPANRKR4"].ToString();
                    or1.Parameters.Add("ABPALFDNR4", OracleType.NVarChar).Value = dwData["ABPALFDNR4"].ToString();
                    or1.Parameters.Add("ABPAFOLGEV4", OracleType.NVarChar).Value = dwData["ABPAFOLGEV4"].ToString();
                    or1.Parameters.Add("ABPAFOLGEB4", OracleType.NVarChar).Value = dwData["ABPAFOLGEB4"].ToString();
                    or1.Parameters.Add("ABPVERSAEND", OracleType.NVarChar).Value = dwData["ABPVERSAEND"].ToString();
                    or1.Parameters.Add("ABPVERSZL", OracleType.NVarChar).Value = dwData["ABPVERSZL"].ToString();
                    or1.Parameters.Add("ABPTLFREIG", OracleType.NVarChar).Value = dwData["ABPTLFREIG"].ToString();
                    or1.Parameters.Add("ABPTLFMG", OracleType.NVarChar).Value = dwData["ABPTLFMG"].ToString();
                    or1.Parameters.Add("ABPFREIGKZ", OracleType.NVarChar).Value = dwData["ABPFREIGKZ"].ToString();
                    or1.Parameters.Add("ABPLMAFOLGE", OracleType.NVarChar).Value = dwData["ABPLMAFOLGE"].ToString();
                    or1.Parameters.Add("ABPENDAUFM", OracleType.NVarChar).Value = dwData["ABPENDAUFM"].ToString();
                    or1.Parameters.Add("ABPZAUFM", OracleType.NVarChar).Value = dwData["ABPZAUFM"].ToString();
                    or1.Parameters.Add("ABPLIEFNR", OracleType.NVarChar).Value = dwData["ABPLIEFNR"].ToString();
                    or1.Parameters.Add("ABPGESSTA", OracleType.NVarChar).Value = dwData["ABPGESSTA"].ToString();
                    or1.Parameters.Add("ABPKDSTA", OracleType.NVarChar).Value = dwData["ABPKDSTA"].ToString();
                    or1.Parameters.Add("ABPWSSTA", OracleType.NVarChar).Value = dwData["ABPWSSTA"].ToString();
                    or1.Parameters.Add("ABPAPSTA", OracleType.NVarChar).Value = dwData["ABPAPSTA"].ToString();
                    or1.Parameters.Add("ABPRZSTA", OracleType.NVarChar).Value = dwData["ABPRZSTA"].ToString();
                    or1.Parameters.Add("ABPWPSTA", OracleType.NVarChar).Value = dwData["ABPWPSTA"].ToString();
                    or1.Parameters.Add("ABPWBSTA", OracleType.NVarChar).Value = dwData["ABPWBSTA"].ToString();
                    or1.Parameters.Add("ABPABSTA", OracleType.NVarChar).Value = dwData["ABPABSTA"].ToString();
                    or1.Parameters.Add("ABPERLKZ", OracleType.NVarChar).Value = dwData["ABPERLKZ"].ToString();
                    or1.Parameters.Add("ABPERLDAT", OracleType.NVarChar).Value = dwData["ABPERLDAT"].ToString();
                    or1.Parameters.Add("ABPBEWKZ", OracleType.NVarChar).Value = dwData["ABPBEWKZ"].ToString();
                    or1.Parameters.Add("ABPDRKZ1", OracleType.NVarChar).Value = dwData["ABPDRKZ1"].ToString();
                    or1.Parameters.Add("ABPDRKZ2", OracleType.NVarChar).Value = dwData["ABPDRKZ2"].ToString();
                    or1.Parameters.Add("ABPDRKZ3", OracleType.NVarChar).Value = dwData["ABPDRKZ3"].ToString();
                    or1.Parameters.Add("ABPDRKZ4", OracleType.NVarChar).Value = dwData["ABPDRKZ4"].ToString();
                    or1.Parameters.Add("ABPDRKZ5", OracleType.NVarChar).Value = dwData["ABPDRKZ5"].ToString();
                    or1.Parameters.Add("ABPDRKZ6", OracleType.NVarChar).Value = dwData["ABPDRKZ6"].ToString();
                    or1.Parameters.Add("ABPDRKZ7", OracleType.NVarChar).Value = dwData["ABPDRKZ7"].ToString();
                    or1.Parameters.Add("ABPDRKZ8", OracleType.NVarChar).Value = dwData["ABPDRKZ8"].ToString();
                    or1.Parameters.Add("ABPDRKZ9", OracleType.NVarChar).Value = dwData["ABPDRKZ9"].ToString();
                    or1.Parameters.Add("ABPDRKZ10", OracleType.NVarChar).Value = dwData["ABPDRKZ10"].ToString();
                    or1.Parameters.Add("ABPDR1USER", OracleType.NVarChar).Value = dwData["ABPDR1USER"].ToString();
                    or1.Parameters.Add("ABPDR1DAT", OracleType.NVarChar).Value = dwData["ABPDR1DAT"].ToString();
                    or1.Parameters.Add("ABPDR8USER", OracleType.NVarChar).Value = dwData["ABPDR8USER"].ToString();
                    or1.Parameters.Add("ABPDR8DAT", OracleType.NVarChar).Value = dwData["ABPDR8DAT"].ToString();
                    or1.Parameters.Add("ABPRETOURZL", OracleType.NVarChar).Value = dwData["ABPRETOURZL"].ToString();
                    or1.Parameters.Add("ABPRPCOUNTAK", OracleType.NVarChar).Value = dwData["ABPRPCOUNTAK"].ToString();
                    or1.Parameters.Add("ABPURAUFKRS", OracleType.NVarChar).Value = dwData["ABPURAUFKRS"].ToString();
                    or1.Parameters.Add("ABPURAUFLFD", OracleType.NVarChar).Value = dwData["ABPURAUFLFD"].ToString();
                    or1.Parameters.Add("ABPURAUFPOS", OracleType.NVarChar).Value = dwData["ABPURAUFPOS"].ToString();
                    or1.Parameters.Add("ABPASAUFKRS", OracleType.NVarChar).Value = dwData["ABPASAUFKRS"].ToString();
                    or1.Parameters.Add("ABPASAUFLFD", OracleType.NVarChar).Value = dwData["ABPASAUFLFD"].ToString();
                    or1.Parameters.Add("ABPASAUFPOS", OracleType.NVarChar).Value = dwData["ABPASAUFPOS"].ToString();
                    or1.Parameters.Add("ABPREAFOLGE", OracleType.NVarChar).Value = dwData["ABPREAFOLGE"].ToString();
                    or1.Parameters.Add("ABPRWKRS", OracleType.NVarChar).Value = dwData["ABPRWKRS"].ToString();
                    or1.Parameters.Add("ABPRWLFD", OracleType.NVarChar).Value = dwData["ABPRWLFD"].ToString();
                    or1.Parameters.Add("ABPSTKNRKR", OracleType.NVarChar).Value = dwData["ABPSTKNRKR"].ToString();
                    or1.Parameters.Add("ABPSERIE", OracleType.NVarChar).Value = dwData["ABPSERIE"].ToString();
                    or1.Parameters.Add("ABPAGBKZ", OracleType.NVarChar).Value = dwData["ABPAGBKZ"].ToString();
                    or1.Parameters.Add("ABPWAART", OracleType.NVarChar).Value = dwData["ABPWAART"].ToString();
                    or1.Parameters.Add("ABPANZSTK", OracleType.NVarChar).Value = dwData["ABPANZSTK"].ToString();
                    or1.Parameters.Add("ABPZUGETGES", OracleType.NVarChar).Value = dwData["ABPZUGETGES"].ToString();
                    or1.Parameters.Add("ABPSTKKZ", OracleType.NVarChar).Value = dwData["ABPSTKKZ"].ToString();
                    or1.Parameters.Add("ABPSTKLG", OracleType.NVarChar).Value = dwData["ABPSTKLG"].ToString();
                    or1.Parameters.Add("ABPANZSTKR", OracleType.NVarChar).Value = dwData["ABPANZSTKR"].ToString();
                    or1.Parameters.Add("ABPABZKZ", OracleType.NVarChar).Value = dwData["ABPABZKZ"].ToString();
                    or1.Parameters.Add("ABPBDEKZ", OracleType.NVarChar).Value = dwData["ABPBDEKZ"].ToString();
                    or1.Parameters.Add("ABPSUBSYS", OracleType.NVarChar).Value = dwData["ABPSUBSYS"].ToString();
                    or1.Parameters.Add("ABPDATBDE", OracleType.NVarChar).Value = dwData["ABPDATBDE"].ToString();
                    or1.Parameters.Add("ABPUHRBDE", OracleType.NVarChar).Value = dwData["ABPUHRBDE"].ToString();
                    or1.Parameters.Add("ABPDISPOKZ", OracleType.NVarChar).Value = dwData["ABPDISPOKZ"].ToString();
                    or1.Parameters.Add("ABPSCHLICHTE", OracleType.NVarChar).Value = dwData["ABPSCHLICHTE"].ToString();
                    or1.Parameters.Add("ABPZZUSATZ", OracleType.NVarChar).Value = dwData["ABPZZUSATZ"].ToString();
                    or1.Parameters.Add("ABPZZUSKZ", OracleType.NVarChar).Value = dwData["ABPZZUSKZ"].ToString();
                    or1.Parameters.Add("ABPSZUSTAND", OracleType.NVarChar).Value = dwData["ABPSZUSTAND"].ToString();
                    or1.Parameters.Add("ABPIZUSTAND", OracleType.NVarChar).Value = dwData["ABPIZUSTAND"].ToString();
                    or1.Parameters.Add("ABPSZUSATZKZ1", OracleType.NVarChar).Value = dwData["ABPSZUSATZKZ1"].ToString();
                    or1.Parameters.Add("ABPSZUSATZKZ2", OracleType.NVarChar).Value = dwData["ABPSZUSATZKZ2"].ToString();
                    or1.Parameters.Add("ABPSZUSATZKZ3", OracleType.NVarChar).Value = dwData["ABPSZUSATZKZ3"].ToString();
                    or1.Parameters.Add("ABPSZUSATZKZ4", OracleType.NVarChar).Value = dwData["ABPSZUSATZKZ4"].ToString();
                    or1.Parameters.Add("ABPWERKE", OracleType.NVarChar).Value = dwData["ABPWERKE"].ToString();
                    or1.Parameters.Add("ABPLBMUSTR", OracleType.NVarChar).Value = dwData["ABPLBMUSTR"].ToString();
                    or1.Parameters.Add("ABPFBMUSTR", OracleType.NVarChar).Value = dwData["ABPFBMUSTR"].ToString();
                    or1.Parameters.Add("ABPREAUFKRS", OracleType.NVarChar).Value = dwData["ABPREAUFKRS"].ToString();
                    or1.Parameters.Add("ABPREAUFLFD", OracleType.NVarChar).Value = dwData["ABPREAUFLFD"].ToString();
                    or1.Parameters.Add("ABPREAUFPOS", OracleType.NVarChar).Value = dwData["ABPREAUFPOS"].ToString();
                    or1.Parameters.Add("ABPLTVORL", OracleType.NVarChar).Value = dwData["ABPLTVORL"].ToString();
                    or1.Parameters.Add("ABPFDZ", OracleType.NVarChar).Value = dwData["ABPFDZ"].ToString();
                    or1.Parameters.Add("ABPARTEX", OracleType.NVarChar).Value = dwData["ABPARTEX"].ToString();
                    or1.Parameters.Add("ABPLETEILNR", OracleType.NVarChar).Value = dwData["ABPLETEILNR"].ToString();
                    or1.Parameters.Add("ABPANSNR", OracleType.NVarChar).Value = dwData["ABPANSNR"].ToString();
                    or1.Parameters.Add("ABPUPOS", OracleType.NVarChar).Value = dwData["ABPUPOS"].ToString();
                    or1.Parameters.Add("ABPTP", OracleType.NVarChar).Value = dwData["ABPTP"].ToString();
                    or1.Parameters.Add("ABPLBDENR", OracleType.NVarChar).Value = dwData["ABPLBDENR"].ToString();
                    or1.Parameters.Add("ABPTMCOUNT", OracleType.NVarChar).Value = dwData["ABPTMCOUNT"].ToString();
                    or1.Parameters.Add("ABPTMCOUNTAK", OracleType.NVarChar).Value = dwData["ABPTMCOUNTAK"].ToString();
                    or1.Parameters.Add("ABPKDPARTIE", OracleType.NVarChar).Value = dwData["ABPKDPARTIE"].ToString();
                    or1.Parameters.Add("ABPBAHNKZ", OracleType.NVarChar).Value = dwData["ABPBAHNKZ"].ToString();
                    or1.Parameters.Add("ABPGAENGE", OracleType.NVarChar).Value = dwData["ABPGAENGE"].ToString();
                    or1.Parameters.Add("ABPZWTWAHL", OracleType.NVarChar).Value = dwData["ABPZWTWAHL"].ToString();
                    or1.Parameters.Add("ABPDIVWLFM", OracleType.NVarChar).Value = dwData["ABPDIVWLFM"].ToString();
                    or1.Parameters.Add("ABPDIVWKG", OracleType.NVarChar).Value = dwData["ABPDIVWKG"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    #region=====Part2-1-1-1=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                       + "ABPDISPOST=:ABPDISPOST,"
                       + "ABPKETTAUFT=:ABPKETTAUFT,"
                       + "ABPKETTGARN=:ABPKETTGARN,"
                       + "ABPSPGRD=:ABPSPGRD,"
                       + "ABPSPBENID=:ABPSPBENID "
                       + " WHERE  "
                       + "  ABPFILLER1=:ABPFILLER1 ";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPDISPOST", OracleType.NVarChar).Value = dwData["ABPDISPOST"].ToString();
                    or1.Parameters.Add("ABPKETTAUFT", OracleType.NVarChar).Value = dwData["ABPKETTAUFT"].ToString();
                    or1.Parameters.Add("ABPKETTGARN", OracleType.NVarChar).Value = dwData["ABPKETTGARN"].ToString();
                    or1.Parameters.Add("ABPSPGRD", OracleType.NVarChar).Value = dwData["ABPSPGRD"].ToString();
                    or1.Parameters.Add("ABPSPBENID", OracleType.NVarChar).Value = dwData["ABPSPBENID"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    #region=====Part2-1-1-2=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                   + "ABPSPDAT=:ABPSPDAT,"
                   + "ABPLMDAT=:ABPLMDAT,"
                   + "ABPLMZT=:ABPLMZT,"
                   + "ABPWPLKZ=:ABPWPLKZ,"
                   + "ABPKKUNDNR=:ABPKKUNDNR,"
                   + "ABPKLAND=:ABPKLAND,"
                   + "ABPKVB=:ABPKVB,"
                   + "ABPKVG=:ABPKVG "
                   + " WHERE  "
                   + "  ABPFILLER1=:ABPFILLER1 ";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPSPDAT", OracleType.NVarChar).Value = dwData["ABPSPDAT"].ToString();
                    or1.Parameters.Add("ABPLMDAT", OracleType.NVarChar).Value = dwData["ABPLMDAT"].ToString();
                    or1.Parameters.Add("ABPLMZT", OracleType.NVarChar).Value = dwData["ABPLMZT"].ToString();
                    or1.Parameters.Add("ABPWPLKZ", OracleType.NVarChar).Value = dwData["ABPWPLKZ"].ToString();
                    or1.Parameters.Add("ABPKKUNDNR", OracleType.NVarChar).Value = dwData["ABPKKUNDNR"].ToString();
                    or1.Parameters.Add("ABPKLAND", OracleType.NVarChar).Value = dwData["ABPKLAND"].ToString();
                    or1.Parameters.Add("ABPKVB", OracleType.NVarChar).Value = dwData["ABPKVB"].ToString();
                    or1.Parameters.Add("ABPKVG", OracleType.NVarChar).Value = dwData["ABPKVG"].ToString();
                    Connect2Proxy(or1);
                    #endregion

                    #region=====Part2-1-2-1=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                   + "ABPKPROGRP=:ABPKPROGRP,"
                   + "ABPKARTGRP=:ABPKARTGRP,"
                   + "ABPKVKZ=:ABPKVKZ,"
                   + "ABPLAEVON=:ABPLAEVON,"
                   + "ABPLAEBIS=:ABPLAEBIS,"
                   + "ABPSTDLAE=:ABPSTDLAE,"
                   + "ABPMGV=:ABPMGV,"
                   + "ABPMGB=:ABPMGB "
                   + " WHERE  "
                   + "  ABPFILLER1=:ABPFILLER1";

                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPKPROGRP", OracleType.NVarChar).Value = dwData["ABPKPROGRP"].ToString();
                    or1.Parameters.Add("ABPKARTGRP", OracleType.NVarChar).Value = dwData["ABPKARTGRP"].ToString();
                    or1.Parameters.Add("ABPKVKZ", OracleType.NVarChar).Value = dwData["ABPKVKZ"].ToString();
                    or1.Parameters.Add("ABPLAEVON", OracleType.NVarChar).Value = dwData["ABPLAEVON"].ToString();
                    or1.Parameters.Add("ABPLAEBIS", OracleType.NVarChar).Value = dwData["ABPLAEBIS"].ToString();
                    or1.Parameters.Add("ABPSTDLAE", OracleType.NVarChar).Value = dwData["ABPSTDLAE"].ToString();
                    or1.Parameters.Add("ABPMGV", OracleType.NVarChar).Value = dwData["ABPMGV"].ToString();
                    or1.Parameters.Add("ABPMGB", OracleType.NVarChar).Value = dwData["ABPMGB"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    #region=====Part2-1-2-2=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
           + "ABPPAS=:ABPPAS,"
           + "ABPPAI=:ABPPAI,"
           + "ABPAZUTEIL=:ABPAZUTEIL,"
           + "ABPZUTART=:ABPZUTART,"
           + "ABPFA=:ABPFA,"
           + "ABPGA=:ABPGA,"
           + "ABPQA=:ABPQA "
           + " WHERE  "
           + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPPAS", OracleType.NVarChar).Value = dwData["ABPPAS"].ToString();
                    or1.Parameters.Add("ABPPAI", OracleType.NVarChar).Value = dwData["ABPPAI"].ToString();
                    or1.Parameters.Add("ABPAZUTEIL", OracleType.NVarChar).Value = dwData["ABPAZUTEIL"].ToString();
                    or1.Parameters.Add("ABPZUTART", OracleType.NVarChar).Value = dwData["ABPZUTART"].ToString();
                    or1.Parameters.Add("ABPFA", OracleType.NVarChar).Value = dwData["ABPFA"].ToString();
                    or1.Parameters.Add("ABPGA", OracleType.NVarChar).Value = dwData["ABPGA"].ToString();
                    or1.Parameters.Add("ABPQA", OracleType.NVarChar).Value = dwData["ABPQA"].ToString();
                    Connect2Proxy(or1);
                    #endregion

                    #region=====Part2-2-1=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
           + "ABPMAFZST=:ABPMAFZST,"
           + "ABPQPKTH=:ABPQPKTH,"
           + "ABPQPKTLH=:ABPQPKTLH,"
           + "ABPSTKNEUTR=:ABPSTKNEUTR,"
           + "ABPREGEL=:ABPREGEL,"
           + "ABPSTAFFNR=:ABPSTAFFNR,"
           + "ABPWERKEKZ=:ABPWERKEKZ,"
           + "ABPWKSTKRS=:ABPWKSTKRS,"
           + "ABPWKST=:ABPWKST,"
           + "ABPWKART=:ABPWKART,"
           + "ABPWMNRKRS=:ABPWMNRKRS,"
           + "ABPWMLFDNR=:ABPWMLFDNR,"
           + "ABPWMPOS=:ABPWMPOS,"
           + "ABPWMODNR=:ABPWMODNR,"
           + "ABPWINTV=:ABPWINTV,"
           + "ABPWKENN=:ABPWKENN,"
           + "ABPWSTOERGRD=:ABPWSTOERGRD,"
           + "ABPWAKSTKRS=:ABPWAKSTKRS,"
           + "ABPWAKST=:ABPWAKST,"
           + "ABPWPERSNR=:ABPWPERSNR "
           + " WHERE  "
           + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPMAFZST", OracleType.NVarChar).Value = dwData["ABPMAFZST"].ToString();
                    or1.Parameters.Add("ABPQPKTH", OracleType.NVarChar).Value = dwData["ABPQPKTH"].ToString();
                    or1.Parameters.Add("ABPQPKTLH", OracleType.NVarChar).Value = dwData["ABPQPKTLH"].ToString();
                    or1.Parameters.Add("ABPSTKNEUTR", OracleType.NVarChar).Value = dwData["ABPSTKNEUTR"].ToString();
                    or1.Parameters.Add("ABPREGEL", OracleType.NVarChar).Value = dwData["ABPREGEL"].ToString();
                    or1.Parameters.Add("ABPSTAFFNR", OracleType.NVarChar).Value = dwData["ABPSTAFFNR"].ToString();
                    or1.Parameters.Add("ABPWERKEKZ", OracleType.NVarChar).Value = dwData["ABPWERKEKZ"].ToString();
                    or1.Parameters.Add("ABPWKSTKRS", OracleType.NVarChar).Value = dwData["ABPWKSTKRS"].ToString();
                    or1.Parameters.Add("ABPWKST", OracleType.NVarChar).Value = dwData["ABPWKST"].ToString();
                    or1.Parameters.Add("ABPWKART", OracleType.NVarChar).Value = dwData["ABPWKART"].ToString();
                    or1.Parameters.Add("ABPWMNRKRS", OracleType.NVarChar).Value = dwData["ABPWMNRKRS"].ToString();
                    or1.Parameters.Add("ABPWMLFDNR", OracleType.NVarChar).Value = dwData["ABPWMLFDNR"].ToString();
                    or1.Parameters.Add("ABPWMPOS", OracleType.NVarChar).Value = dwData["ABPWMPOS"].ToString();
                    or1.Parameters.Add("ABPWMODNR", OracleType.NVarChar).Value = dwData["ABPWMODNR"].ToString();
                    or1.Parameters.Add("ABPWINTV", OracleType.NVarChar).Value = dwData["ABPWINTV"].ToString();
                    or1.Parameters.Add("ABPWKENN", OracleType.NVarChar).Value = dwData["ABPWKENN"].ToString();
                    or1.Parameters.Add("ABPWSTOERGRD", OracleType.NVarChar).Value = dwData["ABPWSTOERGRD"].ToString();
                    or1.Parameters.Add("ABPWAKSTKRS", OracleType.NVarChar).Value = dwData["ABPWAKSTKRS"].ToString();
                    or1.Parameters.Add("ABPWAKST", OracleType.NVarChar).Value = dwData["ABPWAKST"].ToString();
                    or1.Parameters.Add("ABPWPERSNR", OracleType.NVarChar).Value = dwData["ABPWPERSNR"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    #region=====Part2-2-2-1-1=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                        + "ABPWDATV=:ABPWDATV,"
                        + "ABPWZEITV=:ABPWZEITV,"
                        + "ABPWDATB=:ABPWDATB,"
                        + "ABPWZEITB=:ABPWZEITB "
                        + " WHERE  "
                        + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPWDATV", OracleType.NVarChar).Value = dwData["ABPWDATV"].ToString();
                    or1.Parameters.Add("ABPWZEITV", OracleType.NVarChar).Value = dwData["ABPWZEITV"].ToString();
                    or1.Parameters.Add("ABPWDATB", OracleType.NVarChar).Value = dwData["ABPWDATB"].ToString();
                    or1.Parameters.Add("ABPWZEITB", OracleType.NVarChar).Value = dwData["ABPWZEITB"].ToString();


                    Connect2Proxy(or1);
                    #endregion
                    #region=====Part2-2-2-1-2=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                        + "ABPWSTA=:ABPWSTA,"
                        + "ABPFKALK=:ABPFKALK,"
                        + "ABPLIEFDATN=:ABPLIEFDATN,"
                        + "ABPLAEAENDE=:ABPLAEAENDE,"
                        + "ABPLAEAENDA=:ABPLAEAENDA "
                        + " WHERE  "
                        + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPWSTA", OracleType.NVarChar).Value = dwData["ABPWSTA"].ToString();
                    or1.Parameters.Add("ABPFKALK", OracleType.NVarChar).Value = dwData["ABPFKALK"].ToString();
                    or1.Parameters.Add("ABPLIEFDATN", OracleType.NVarChar).Value = dwData["ABPLIEFDATN"].ToString();
                    or1.Parameters.Add("ABPLAEAENDE", OracleType.NVarChar).Value = dwData["ABPLAEAENDE"].ToString();
                    or1.Parameters.Add("ABPLAEAENDA", OracleType.NVarChar).Value = dwData["ABPLAEAENDA"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    #region=====Part2-2-2-2=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                        + "ABPDMWAKZ=:ABPDMWAKZ,"
                        + "ABPDMART=:ABPDMART,"
                        + "ABPDMVAR=:ABPDMVAR,"
                        + "ABPDMDESS=:ABPDMDESS,"
                        + "ABPDMCOLORIT=:ABPDMCOLORIT,"
                        + "ABPDMFARBE=:ABPDMFARBE,"
                        + "ABPDMBESCHICH=:ABPDMBESCHICH "
                        + " WHERE  "
                        + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();

                    or1.Parameters.Add("ABPDMWAKZ", OracleType.NVarChar).Value = dwData["ABPDMWAKZ"].ToString();
                    or1.Parameters.Add("ABPDMART", OracleType.NVarChar).Value = dwData["ABPDMART"].ToString();
                    or1.Parameters.Add("ABPDMVAR", OracleType.NVarChar).Value = dwData["ABPDMVAR"].ToString();
                    or1.Parameters.Add("ABPDMDESS", OracleType.NVarChar).Value = dwData["ABPDMDESS"].ToString();
                    or1.Parameters.Add("ABPDMCOLORIT", OracleType.NVarChar).Value = dwData["ABPDMCOLORIT"].ToString();
                    or1.Parameters.Add("ABPDMFARBE", OracleType.NVarChar).Value = dwData["ABPDMFARBE"].ToString();
                    or1.Parameters.Add("ABPDMBESCHICH", OracleType.NVarChar).Value = dwData["ABPDMBESCHICH"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    #region=====Par3=======
                    or1 = OracleDB.CreateCommand();
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                        + "ABPDKART=:ABPDKART,"
           + "ABPDKVAR=:ABPDKVAR,"
           + "ABPDKFARBE=:ABPDKFARBE,"
           + "ABPDKBRUT=:ABPDKBRUT,"
           + "ABPGENEHMKZ=:ABPGENEHMKZ,"
           + "ABPSTUEART=:ABPSTUEART,"
           + "ABPCOMPKZ=:ABPCOMPKZ,"
           + "ABPPOSTYP=:ABPPOSTYP,"
           + "ABPORDER=:ABPORDER,"
           + "ABPNPGRUND=:ABPNPGRUND,"
           + "ABPREWEIL=:ABPREWEIL,"
           + "ABPFSCHL=:ABPFSCHL,"
           + "ABPKSTKRS=:ABPKSTKRS,"
           + "ABPKST=:ABPKST,"
           + "ABPMURW=:ABPMURW,"
           + "ABPMUVB=:ABPMUVB,"
           + "ABPMUFW=:ABPMUFW,"
           + "ABPMUPF=:ABPMUPF,"
           + "ABPERSTFB=:ABPERSTFB,"
           + "ABPERSTDR=:ABPERSTDR,"
           + "ABPERSTBE=:ABPERSTBE,"
           + "ABPMUCTOD=:ABPMUCTOD,"
           + "ABPKDFREI=:ABPKDFREI,"
           + "ABPREZFB=:ABPREZFB,"
           + "ABPREZDR=:ABPREZDR,"
           + "ABPPRUEF=:ABPPRUEF,"
           + "ABPNIXWE=:ABPNIXWE,"
           + "ABPCOLSTA=:ABPCOLSTA,"
           + "ABPFBSTA=:ABPFBSTA,"
           + "ABPBAHNNR=:ABPBAHNNR,"
           + "ABPBAHNBRT=:ABPBAHNBRT,"
           + "ABPFLBEDECK=:ABPFLBEDECK,"
           + "ABPDATABDE=:ABPDATABDE,"
           + "ABPUHRABDE=:ABPUHRABDE,"
           + "ABPLOEKZ=:ABPLOEKZ,"
           + "ABPTERMDAT=:ABPTERMDAT,"
           + "ABPPRFI=:ABPPRFI,"
           + "ABPPRVAR=:ABPPRVAR,"
           + "ABPPRBE=:ABPPRBE,"
           + "ABPPRZU=:ABPPRZU,"
           + "ABPPRDESS=:ABPPRDESS,"
           + "ABPZUSATZ1=:ABPZUSATZ1,"
           + "ABPZUSATZ2=:ABPZUSATZ2,"
           + "ABPZUSATZ3=:ABPZUSATZ3,"
           + "ABPZUSATZ4=:ABPZUSATZ4,"
           + "ABPZUSATZ5=:ABPZUSATZ5,"
           + "ABPFLAG1=:ABPFLAG1,"
           + "ABPFLAG2=:ABPFLAG2,"
           + "ABPFLAG3=:ABPFLAG3,"
           + "ABPFLAG4=:ABPFLAG4,"
           + "ABPFLAG5=:ABPFLAG5,"
           + "ABPORGMG=:ABPORGMG,"
           + "ABPDIFFMG=:ABPDIFFMG,"
           + "ABPRARTKZ=:ABPRARTKZ,"
           + "ABPSTARTDATN=:ABPSTARTDATN,"
           + "ABPAESTAT=:ABPAESTAT,"
           + "ABPLBAUFKRS=:ABPLBAUFKRS,"
           + "ABPLBAUFLFD=:ABPLBAUFLFD,"
           + "ABPLBAUFPOS=:ABPLBAUFPOS,"
           + "ABPVEAUFTRAG=:ABPVEAUFTRAG,"
           + "ABPREGBLOG=:ABPREGBLOG,"
           + "ABPREGBDATE=:ABPREGBDATE,"
           + "ABPPROJNR=:ABPPROJNR,"
           + "ABPSHADE=:ABPSHADE,"
           + "ABPSHADEUNCL=:ABPSHADEUNCL,"
           + "ABPLICHTART=:ABPLICHTART,"
           + "ABPLINE=:ABPLINE,"
           + "ABPAENDZL=:ABPAENDZL,"
           + "ABPAENDBEN=:ABPAENDBEN,"
           + "ABPAENDDAT=:ABPAENDDAT,"
           + "ABPNEUBEN=:ABPNEUBEN,"
           + "ABPNEUDAT=:ABPNEUDAT"
           + " WHERE  "
           + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();
                    or1.Parameters.Add("ABPDKART", OracleType.NVarChar).Value = dwData["ABPDKART"].ToString();
                    or1.Parameters.Add("ABPDKVAR", OracleType.NVarChar).Value = dwData["ABPDKVAR"].ToString();
                    or1.Parameters.Add("ABPDKFARBE", OracleType.NVarChar).Value = dwData["ABPDKFARBE"].ToString();
                    or1.Parameters.Add("ABPDKBRUT", OracleType.NVarChar).Value = dwData["ABPDKBRUT"].ToString();
                    or1.Parameters.Add("ABPGENEHMKZ", OracleType.NVarChar).Value = dwData["ABPGENEHMKZ"].ToString();
                    or1.Parameters.Add("ABPSTUEART", OracleType.NVarChar).Value = dwData["ABPSTUEART"].ToString();
                    or1.Parameters.Add("ABPCOMPKZ", OracleType.NVarChar).Value = dwData["ABPCOMPKZ"].ToString();
                    or1.Parameters.Add("ABPPOSTYP", OracleType.NVarChar).Value = dwData["ABPPOSTYP"].ToString();
                    or1.Parameters.Add("ABPORDER", OracleType.NVarChar).Value = dwData["ABPORDER"].ToString();
                    or1.Parameters.Add("ABPNPGRUND", OracleType.NVarChar).Value = dwData["ABPNPGRUND"].ToString();
                    or1.Parameters.Add("ABPREWEIL", OracleType.NVarChar).Value = dwData["ABPREWEIL"].ToString();
                    or1.Parameters.Add("ABPFSCHL", OracleType.NVarChar).Value = dwData["ABPFSCHL"].ToString();
                    or1.Parameters.Add("ABPKSTKRS", OracleType.NVarChar).Value = dwData["ABPKSTKRS"].ToString();
                    or1.Parameters.Add("ABPKST", OracleType.NVarChar).Value = dwData["ABPKST"].ToString();
                    or1.Parameters.Add("ABPMURW", OracleType.NVarChar).Value = dwData["ABPMURW"].ToString();
                    or1.Parameters.Add("ABPMUVB", OracleType.NVarChar).Value = dwData["ABPMUVB"].ToString();
                    or1.Parameters.Add("ABPMUFW", OracleType.NVarChar).Value = dwData["ABPMUFW"].ToString();
                    or1.Parameters.Add("ABPMUPF", OracleType.NVarChar).Value = dwData["ABPMUPF"].ToString();
                    or1.Parameters.Add("ABPERSTFB", OracleType.NVarChar).Value = dwData["ABPERSTFB"].ToString();
                    or1.Parameters.Add("ABPERSTDR", OracleType.NVarChar).Value = dwData["ABPERSTDR"].ToString();
                    or1.Parameters.Add("ABPERSTBE", OracleType.NVarChar).Value = dwData["ABPERSTBE"].ToString();
                    or1.Parameters.Add("ABPMUCTOD", OracleType.NVarChar).Value = dwData["ABPMUCTOD"].ToString();
                    or1.Parameters.Add("ABPKDFREI", OracleType.NVarChar).Value = dwData["ABPKDFREI"].ToString();
                    or1.Parameters.Add("ABPREZFB", OracleType.NVarChar).Value = dwData["ABPREZFB"].ToString();
                    or1.Parameters.Add("ABPREZDR", OracleType.NVarChar).Value = dwData["ABPREZDR"].ToString();
                    or1.Parameters.Add("ABPPRUEF", OracleType.NVarChar).Value = dwData["ABPPRUEF"].ToString();
                    or1.Parameters.Add("ABPNIXWE", OracleType.NVarChar).Value = dwData["ABPNIXWE"].ToString();
                    or1.Parameters.Add("ABPCOLSTA", OracleType.NVarChar).Value = dwData["ABPCOLSTA"].ToString();
                    or1.Parameters.Add("ABPFBSTA", OracleType.NVarChar).Value = dwData["ABPFBSTA"].ToString();
                    or1.Parameters.Add("ABPBAHNNR", OracleType.NVarChar).Value = dwData["ABPBAHNNR"].ToString();
                    or1.Parameters.Add("ABPBAHNBRT", OracleType.NVarChar).Value = dwData["ABPBAHNBRT"].ToString();
                    or1.Parameters.Add("ABPFLBEDECK", OracleType.NVarChar).Value = dwData["ABPFLBEDECK"].ToString();
                    or1.Parameters.Add("ABPDATABDE", OracleType.NVarChar).Value = dwData["ABPDATABDE"].ToString();
                    or1.Parameters.Add("ABPUHRABDE", OracleType.NVarChar).Value = dwData["ABPUHRABDE"].ToString();
                    or1.Parameters.Add("ABPLOEKZ", OracleType.NVarChar).Value = dwData["ABPLOEKZ"].ToString();
                    or1.Parameters.Add("ABPTERMDAT", OracleType.NVarChar).Value = dwData["ABPTERMDAT"].ToString();
                    or1.Parameters.Add("ABPPRFI", OracleType.NVarChar).Value = dwData["ABPPRFI"].ToString();
                    or1.Parameters.Add("ABPPRVAR", OracleType.NVarChar).Value = dwData["ABPPRVAR"].ToString();
                    or1.Parameters.Add("ABPPRBE", OracleType.NVarChar).Value = dwData["ABPPRBE"].ToString();
                    or1.Parameters.Add("ABPPRZU", OracleType.NVarChar).Value = dwData["ABPPRZU"].ToString();
                    or1.Parameters.Add("ABPPRDESS", OracleType.NVarChar).Value = dwData["ABPPRDESS"].ToString();
                    or1.Parameters.Add("ABPZUSATZ1", OracleType.NVarChar).Value = dwData["ABPZUSATZ1"].ToString();
                    or1.Parameters.Add("ABPZUSATZ2", OracleType.NVarChar).Value = dwData["ABPZUSATZ2"].ToString();
                    or1.Parameters.Add("ABPZUSATZ3", OracleType.NVarChar).Value = dwData["ABPZUSATZ3"].ToString();
                    or1.Parameters.Add("ABPZUSATZ4", OracleType.NVarChar).Value = dwData["ABPZUSATZ4"].ToString();
                    or1.Parameters.Add("ABPZUSATZ5", OracleType.NVarChar).Value = dwData["ABPZUSATZ5"].ToString();
                    or1.Parameters.Add("ABPFLAG1", OracleType.NVarChar).Value = dwData["ABPFLAG1"].ToString();
                    or1.Parameters.Add("ABPFLAG2", OracleType.NVarChar).Value = dwData["ABPFLAG2"].ToString();
                    or1.Parameters.Add("ABPFLAG3", OracleType.NVarChar).Value = dwData["ABPFLAG3"].ToString();
                    or1.Parameters.Add("ABPFLAG4", OracleType.NVarChar).Value = dwData["ABPFLAG4"].ToString();
                    or1.Parameters.Add("ABPFLAG5", OracleType.NVarChar).Value = dwData["ABPFLAG5"].ToString();
                    or1.Parameters.Add("ABPORGMG", OracleType.NVarChar).Value = dwData["ABPORGMG"].ToString();
                    or1.Parameters.Add("ABPDIFFMG", OracleType.NVarChar).Value = dwData["ABPDIFFMG"].ToString();
                    or1.Parameters.Add("ABPRARTKZ", OracleType.NVarChar).Value = dwData["ABPRARTKZ"].ToString();
                    or1.Parameters.Add("ABPSTARTDATN", OracleType.NVarChar).Value = dwData["ABPSTARTDATN"].ToString();
                    or1.Parameters.Add("ABPAESTAT", OracleType.NVarChar).Value = dwData["ABPAESTAT"].ToString();
                    or1.Parameters.Add("ABPLBAUFKRS", OracleType.NVarChar).Value = dwData["ABPLBAUFKRS"].ToString();
                    or1.Parameters.Add("ABPLBAUFLFD", OracleType.NVarChar).Value = dwData["ABPLBAUFLFD"].ToString();
                    or1.Parameters.Add("ABPLBAUFPOS", OracleType.NVarChar).Value = dwData["ABPLBAUFPOS"].ToString();
                    or1.Parameters.Add("ABPVEAUFTRAG", OracleType.NVarChar).Value = dwData["ABPVEAUFTRAG"].ToString();
                    or1.Parameters.Add("ABPREGBLOG", OracleType.NVarChar).Value = dwData["ABPREGBLOG"].ToString();
                    or1.Parameters.Add("ABPREGBDATE", OracleType.NVarChar).Value = dwData["ABPREGBDATE"].ToString();
                    or1.Parameters.Add("ABPPROJNR", OracleType.NVarChar).Value = dwData["ABPPROJNR"].ToString();
                    or1.Parameters.Add("ABPSHADE", OracleType.NVarChar).Value = dwData["ABPSHADE"].ToString();
                    or1.Parameters.Add("ABPSHADEUNCL", OracleType.NVarChar).Value = dwData["ABPSHADEUNCL"].ToString();
                    or1.Parameters.Add("ABPLICHTART", OracleType.NVarChar).Value = dwData["ABPLICHTART"].ToString();
                    or1.Parameters.Add("ABPLINE", OracleType.NVarChar).Value = dwData["ABPLINE"].ToString();
                    or1.Parameters.Add("ABPAENDZL", OracleType.NVarChar).Value = dwData["ABPAENDZL"].ToString();
                    or1.Parameters.Add("ABPAENDBEN", OracleType.NVarChar).Value = dwData["ABPAENDBEN"].ToString();
                    or1.Parameters.Add("ABPAENDDAT", OracleType.NVarChar).Value = dwData["ABPAENDDAT"].ToString();
                    or1.Parameters.Add("ABPNEUBEN", OracleType.NVarChar).Value = dwData["ABPNEUBEN"].ToString();
                    or1.Parameters.Add("ABPNEUDAT", OracleType.NVarChar).Value = dwData["ABPNEUDAT"].ToString();
                    Connect2Proxy(or1);
                    #endregion
                    break;
                default:
                    break;
            }
        }
        public void UpdateICC_ABPOS_EXT(DataRow dwData, int option)
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            string lines = "";
            switch (option)
            {
                case 5:
                    or1.CommandText = "UPDATE ICC_ABPOS_EXT SET "
                        + "ABPGESSTA=:ABPGESSTA"
                        + " WHERE  "
                        + "  ABPFILLER1=:ABPFILLER1";
                    or1.Parameters.Add("ABPFILLER1", OracleType.NVarChar).Value = dwData["ABPFILLER1"].ToString();
                    or1.Parameters.Add("ABPGESSTA", OracleType.NVarChar).Value = dwData["ABPGESSTA"].ToString();
                    break;
                default:
                    break;
            }

            Connect2Proxy(or1);
        }
    }
}
